This query extracts the total number of members who have made a pledge of $50 or more.
1. Browse to IQA.
2. Select Query from the drop-down list and select New.
3. Select your sources:
□ Browse to the Common folder containing business objects.
□ Select the business objects:
■ CsContact
■ CsActivityBasic
4. Define the filtering rules:
□ Select the Filters tab.
□ Mode: Advanced
□ Filter on CSActivityBasic.Activity Type:
■ Property: CSActivityBasic.Activity Type
■ Comparison: Equal
■ Value: PLEDGE
■ Click the + icon to add the filter.
□ Filter on CsActivityBasic.Amount:
■ Property: Activity.Amount
■ Comparison: Greater
■ Value: 50
■ Click the + icon to add the filter.
5. Define the columns that display in the output:
□ Select the Display tab.
□ Display Contact.iMIS ID
■ Property: CsContact.iMIS Id
■ Function: Count
■ Alias: Pledges
■ Order: 1
Note: A default list of columns displays when you select the Display tab. Deselect the columns you do not need. If a column you need is not in the default list, select All from the View drop-down list and scroll down the page to select the desired column.
6. Save your settings.
7. Run the query.